<CFQUERY name="getprojects" datasource="#application.dsn#">
SELECT * FROM projects
</CFQUERY>
<FORM action="/codesaver/index.cfm" method="post">
	<SELECT name="projects" size="1">
	<OPTION value="0"> Select projects
	<CFOUTPUT query="getprojects">
	<OPTION value="#projectid#">#name#</OPTION>
	</CFOUTPUT>
	</SELECT>
</FORM>
